|
Primary |
Foreign Key |
Name |
Data Type |
Length |
Comment |
|
X |
|
CommitteeID |
NUMBER |
|
͹ءÃÃÁ¡ÒõÃǨ |
|
|
X |
DocumentID |
NUMBER |
|
àÍ¡ÊÒà ÍéÒ§ÍÔ§ |
|
|
X |
CommitteeTypeID |
NUMBER |
|
|
|
|
X |
PRID |
NUMBER |
|
àÅ¢·Õè㺢ͫ×éÍ/¨éÒ§/¼ÅÔµ |
|
|
X |
DepartmentID |
NUMBER |
|
ÃËÑÊ˹èǧҹ |
|
|
X |
ReplaceID |
NUMBER |
|
ªØ´¢Í§¤³Ð¡ÃÃÁ¡Ò÷Õè¶Ù¡Â¡àÅÔ¡ä»áÅеÑ駪شãËÁè¹Õé¢Öé¹ÁÒá·¹ |
|
|
|
CommitteeCode |
VARCHAR2(30) |
30 |
ÃËÑÊ͹ءÃÃÁ¡ÒõÃǨ |
|
|
|
CommitteeName |
VARCHAR2(300) |
300 |
ª×èÍ͹ءÃÃÁ¡ÒõÃǨ |
|
|
|
AssignDate |
DATE |
|
Çѹ·Õèáµè§µÑé§ |
|
|
|
CancelDate |
DATE |
|
Çѹ·Õè¡àÅÔ¡ |
|
|
|
Notes |
VARCHAR2(250) |
250 |
¤Ó͸ԺÒ à˵ؼŠ|
|
|
|
Status |
CHAR(1) |
1 |
N=New (Active), |
|
|
|
Create By |
NUMBER |
|
ÊÃéÒ§â´Â |
|
|
|
Create Date |
DATE |
|
ÊÃéÒ§àÁ×èÍÇѹ·Õè |
|
|
|
Update By |
NUMBER |
|
Update â´Â |
|
|
|
Update Date |
DATE |
|
Çѹ·Õè Update |
|
|
|